package com.bw.mapper;

import com.bw.bean.Mov;
import org.apache.ibatis.annotations.Mapper;
import org.apache.ibatis.annotations.Select;

import java.util.List;

/**
* @author 黄久畅
* @description 针对表【mov】的数据库操作Mapper
* @createDate 2024-07-05 08:29:52
* @Entity com.bw.bean.Mov
*/
@Mapper
public interface MovMapper {

    @Select("select * from mov")
    List<Mov> get1();

    @Select("SELECT m.*,d.name FROM mov m,dir d WHERE m.did=d.id")
    List<Mov> get2();

    @Select("SELECT * FROM mov WHERE INSTR(mname,#{name1})")
    List<Mov> get3(String mname1);

    @Select("SELECT m.*,d.name FROM mov m,dir d WHERE m.did=d.id and name=#{name1}")
    List<Mov> get4(String name1);

    @Select("SELECT * FROM mov WHERE mdate BETWEEN #{date1} and #{date2}")
    List<Mov> get5(String date1, String date2);
}




